SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Spectacular yard that gently slopes down to the Brook. With 273' along the brook, this is a special property. Ample space for large gatherings, camp fires or garden space. This light and bright 3 bedroom ranch has been updated over the years, with a modern kitchen and hardwood flooring. Relax by the woodstove in the family room or sit back and enjoy a book in the sunroom. Plenty of rooms for everyone to enjoy. There is a full unfinished basement, a wonderful back deck with a 2024 hot tub. Did I mention the oversized garage? 28 x 60' for parking, workshop area or just extra storage for all the fun toys you may acquire. In 2007 the septic was updated. 2.7 acres of land to enjoy. Located conveniently to shopping and just 15 Minutes to DHMC.
Description:PRICE IMPROVEMENT! This 3 bedroom/2 bathroom home is ready for its next owners! Located in one of Lebanon's most desirable locations, the King's Grant neighborhood, it's close to shopping, dining, and schools, and backs up to Carter Country Club. The first floor features a mudroom or bonus room, office, and utility/laundry room and also connects to the garage. Upstairs, you'll find a large living room with high ceilings, a kitchen featuring brand new stainless steel appliances, and a dining area leading to a large, private deck. A primary bedroom with en-suite 3/4 bath and 2 other bedrooms which share a full bath complete the space. Hanover, Dartmouth Hitchcock Medical Center, and West Lebanon shopping are all within a 15 minute drive. You'll love living in the heart of the Upper Valley!
Description:This charming, secluded 2000 cape has 18+/- acres of land and delightful views of Mt Ascutney. With hardwood floors upstairs and down, good bathrooms, 3 bedrooms, and a lovely open floorplan on the first floor, this is a great home! There's a two car garage plus a very large, detached barn. Plenty of room for gardens and chickens as well as trails. A great one! Private road maintenance fee: $25 per month.
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.
Description:If you are looking for a home that has a country feel, with a scenic country road access, yet offers Windsor VT, Claremont and the Upper Valley of NH, all within a 25 minute drive or less, this location will speak to you. This is a custom built home, that has hillside views (can be improved with some clearing), a brook at the north end of the property, a detached 2 car garage (2016), standby generator, privacy and gardens. Inside you have large spaces, vaulted ceilings, wood beams, a kitchen with a view and granite counters. The stone fireplace goes two stories high. In some houses that would be the focal point, this home offers several. The sunroom, it is sunny and bright, take in the view and stay warm with the gas fireplace. Step out onto the deck and take in the fresh air. The primary suite is large, has direct access to the deck and a bath that is just a dream. There is space for a in-home gym and office. The second floor has an open loft, two large bedrooms and full bath. Radiant heat on the main floor keeps you warm all winter and the newer metal roof gives you peace of mind. Other features: hardwood floors, paved driveway, pellet stove, water filtration, dumbwaiter and more! Delayed showings, showings start at the open house on Saturday 09/07 11am-1pm